package dao;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import pojo.CurriCulum;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

/**
 * 2022.3.16测试成功，由吴俊莹编写完成
 */

public interface CurriCulumDao {
    //显示当前用户的课表
    public JSONArray UserTable(int teacherId,String sj) throws SQLException;

    //用户增加课程安排
    public int InsertKe(JSONArray jsonArray,int id) throws SQLException;

    //修改用户自己的课程安排
    public int UpdateUes(CurriCulum curriCulum) throws SQLException;

    //删除用户自己的课程安排
    public int DelUesr_Up(CurriCulum curriCulum) throws SQLException;

    //打卡已上课程
    public int ClockIn(CurriCulum curriCulum,String xx) throws SQLException;

    //管理员给用户设置权限
    public int SetUser(int teacherId,int level) throws SQLException;

    //管理员查看用户总课时
    public int CheckUser(int teacherId) throws SQLException;

    //用户新增课程时查重
    public ArrayList<String> ChecChong(int id,JSONArray jsonArray) throws SQLException;

    public JSONArray month(String userName,String m,String y) throws SQLException;

    //更改查重
    public ArrayList<String> Upcheck(CurriCulum curriCulum) throws SQLException;

    //管理员查询
    public JSONArray selectAll(String classes,String teaName,String date_One,String date_Two,int all,int limitPag,int splitPag) throws SQLException;

    //班级查重
    public ArrayList<String> banji(JSONArray jsonArray) throws SQLException;

    //总页数
    public int zong(String classes, String teaName, String date_One, String date_Two,int all) throws SQLException;

}
